package studentStatus.constants;

import java.text.SimpleDateFormat;

public interface Sqls {

    String[] columnNames = {"序号","ID", "学号","姓名","性别","籍贯","入学时间","期末评估"};

    String sql_all = "SELECT * from student ;";

    String sql2_add = "insert into student(id,name,gender,hometown,date,evaluation,num)  values (0,?,?,?,?,?,?)";

    String sql3_delete = "delete from student where id=?";

    String sql4_update = "update student set name=?, gender=?, hometown=?,date=?,evaluation = ? ,num=? where id=?";


    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");

    String sql5_add_message = "insert into message_table values(0,?,?,?)";

    String sql6_mess_list = "select name,content,phone from message_table";
}
